A forward-compatible pg_dump?
От | Herouth Maoz |
---|---|
Тема | A forward-compatible pg_dump? |
Дата | |
Msg-id | l03110709b2da35a4661a@[147.233.159.109] обсуждение исходный текст |
Ответы |
Re: [GENERAL] A forward-compatible pg_dump?
|
Список | pgsql-general |
After *months* of delays, we are *finally* going to port all our databases (and that's hundreds of small ones) to 6.4.2 from 6.2.1. So, I took a test-case database and tried to load it from our backup dumps. Ah... Close, but no cigar. Several syntax changes happened over the past two years, including the dropping of archiving (obsoleting the "archive" keyword in the dumps), and a change in the constraint syntax. Also, old pg_dump doesn't dump privileges correctly, and frankly, it would be a pain to enter each database and start granting from memory or a handwritten list... So, I recalled that there was somebody who wrote a forward-compatible pg_dump. Something that works on 6.2.1 (or was it 6.1?) but outputs 6.4 or 6.3 schema syntax. Is that someone still around? If so, can this thingy, wherever I may get it, be used to dump properly from 6.2.1 to 6.4.2, and will it dump grants as well? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma
В списке pgsql-general по дате отправления: